package com.ymt.spi.webserver.tomcat.realm;

public class YmtBizRoleSqlSelector implements BizRoleSqlSelector {

	@Override
	public String getRoleSelectSql() {
		return "select distinct ROLE_ID from p_role where ROLE_ID in (select ROLE_ID from P_ROLE_MEMBER where upper(MEMBER_ID)=upper(?) and MEMBER_TYPE='1' union select R.ROLE_ID from P_ROLE_MEMBER R, P_ORG_USER O where R.MEMBER_ID=O.ORG_ID and upper(O.USER_ID)=upper(?) and R.MEMBER_TYPE='0')";
	}

}
